USE [BMIG_Mensual_POST_CADENA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_M0002_CRSEGUROS]    Script Date: 11/24/2011 14:31:49 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[WASP_M0002_CRSEGUROS]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[WASP_M0002_CRSEGUROS]
GO

USE [BMIG_Mensual_POST_CADENA]
GO

/****** Object:  StoredProcedure [dbo].[WASP_M0002_CRSEGUROS]    Script Date: 11/24/2011 14:31:49 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[WASP_M0002_CRSEGUROS]
AS
BEGIN
	SELECT	* 
	INTO	crseguros
	FROM	seguro_vida_tra
	UNION
	SELECT	*
	FROM	seguro_asisten_pen 
END

GO


